IF NOT EXISTS(SELECT name FROM sysobjects  WHERE name = 'EPOTrackingDetail')
BEGIN 

CREATE TABLE [dbo].[EPOTrackingDetail](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[TrackingId] [UNIQUEIDENTIFIER] NULL,
	[CreatedOn] [DATETIME] NULL,
	[Status] [TINYINT] NULL,
	[CreatedBy] [SMALLINT] NULL,
	[UpdatedOn] [DATETIME] NULL,
	[Description] [NVARCHAR](512) NULL,
      [CreatedByAppUserId] [int] NULL,
 CONSTRAINT [PK_EPOTrackingDetail] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
) ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[EPOTrackingDetail] ADD  CONSTRAINT [DF_EPOTrackingDetail_Id]  DEFAULT (NEWID()) FOR [Id]


ALTER TABLE [dbo].[EPOTrackingDetail] ADD  CONSTRAINT [DF_EPOTrackingDetail_CreatedOn]  DEFAULT (GETDATE()) FOR [CreatedOn]


ALTER TABLE [dbo].[EPOTrackingDetail]  WITH CHECK ADD  CONSTRAINT [FK_EPOTrackingDetail_EPOTracking] FOREIGN KEY([TrackingId])
REFERENCES [dbo].[EPOTracking] ([Id])
ON DELETE CASCADE


ALTER TABLE [dbo].[EPOTrackingDetail] CHECK CONSTRAINT [FK_EPOTrackingDetail_EPOTracking]



end